VERSION 5.00
Object = "{00025600-0000-0000-C000-000000000046}#5.2#0"; "crystl32.ocx"
Begin VB.Form frmINV200 
   BackColor       =   &H8000000D&
   Caption         =   "INV200"
   ClientHeight    =   4320
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   8700
   ControlBox      =   0   'False
   LinkTopic       =   "Form1"
   ScaleHeight     =   4320
   ScaleWidth      =   8700
   StartUpPosition =   3  'Windows Default
   Begin VB.OptionButton OptReport 
      BackColor       =   &H00800000&
      Caption         =   "INV260 -Re-order Point Report"
      BeginProperty Font 
         Name            =   "Verdana"
         Size            =   9
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00E0E0E0&
      Height          =   345
      Index           =   5
      Left            =   1590
      TabIndex        =   9
      Top             =   3165
      Width           =   3870
   End
   Begin VB.OptionButton OptReport 
      BackColor       =   &H00800000&
      Caption         =   "INV250 -Slow and Non-moving Report"
      BeginProperty Font 
         Name            =   "Verdana"
         Size            =   9
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00E0E0E0&
      Height          =   345
      Index           =   4
      Left            =   1260
      TabIndex        =   8
      Top             =   2820
      Width           =   4470
   End
   Begin VB.OptionButton OptReport 
      BackColor       =   &H00800000&
      Caption         =   "INV240 -ABC Analysis Report"
      BeginProperty Font 
         Name            =   "Verdana"
         Size            =   9
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00E0E0E0&
      Height          =   345
      Index           =   3
      Left            =   1020
      TabIndex        =   7
      Top             =   2430
      Width           =   3465
   End
   Begin VB.OptionButton OptReport 
      BackColor       =   &H00800000&
      Caption         =   "INV230 -Inventory Status  Report By Value"
      BeginProperty Font 
         Name            =   "Verdana"
         Size            =   9
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00E0E0E0&
      Height          =   345
      Index           =   2
      Left            =   750
      TabIndex        =   6
      Top             =   2055
      Width           =   5040
   End
   Begin VB.OptionButton OptReport 
      BackColor       =   &H00800000&
      Caption         =   "INV210 + INV220 - Inventory Status  Report By Item+Ware house+Lot"
      BeginProperty Font 
         Name            =   "Verdana"
         Size            =   9
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00E0E0E0&
      Height          =   345
      Index           =   1
      Left            =   570
      TabIndex        =   5
      Top             =   1635
      Width           =   7605
   End
   Begin VB.OptionButton OptReport 
      BackColor       =   &H00800000&
      Caption         =   "INV200 -Inventory Status Sumary Report"
      BeginProperty Font 
         Name            =   "Verdana"
         Size            =   9
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00E0E0E0&
      Height          =   345
      Index           =   0
      Left            =   375
      TabIndex        =   4
      Top             =   1245
      Width           =   4845
   End
   Begin Crystal.CrystalReport CrystalReport1 
      Left            =   5835
      Top             =   795
      _ExtentX        =   741
      _ExtentY        =   741
      _Version        =   348160
      PrintFileLinesPerPage=   60
   End
   Begin VB.CommandButton cmdPrint 
      Caption         =   "&Print"
      Height          =   345
      Left            =   2400
      TabIndex        =   3
      Top             =   3960
      Width           =   930
   End
   Begin VB.CommandButton cmdExit 
      Caption         =   "&Exit"
      Height          =   330
      Left            =   4050
      TabIndex        =   2
      Top             =   3915
      Width           =   1140
   End
   Begin VB.Label lbl 
      BackStyle       =   0  'Transparent
      Caption         =   "Inventory Status"
      BeginProperty Font 
         Name            =   "Verdana"
         Size            =   16.5
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   -1  'True
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00E0E0E0&
      Height          =   495
      Index           =   1
      Left            =   1830
      TabIndex        =   1
      Top             =   435
      Width           =   4560
   End
   Begin VB.Label lbl 
      BackStyle       =   0  'Transparent
      Caption         =   "INV200"
      BeginProperty Font 
         Name            =   "Arial"
         Size            =   18
         Charset         =   0
         Weight          =   700
         Underline       =   -1  'True
         Italic          =   -1  'True
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00E0E0E0&
      Height          =   405
      Index           =   0
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   1980
   End
End
Attribute VB_Name = "frmINV200"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim ReportName As String
Private Sub cmdExit_Click()
Unload frmINV200
End Sub

Private Sub cmdPrint_Click()
'Dim bdate, edate As Date
CrystalReport1.ReportFileName = DDAN & "\" & ReportName
If OptReport(0) = True Then

   FrmReportDateRange.Show 1
   If Reportflg = False Then
        Exit Sub
   End If
'    Dim Objcmd As Command
'    Set Objcmd = New ADODB.Command
'    Objcmd.CommandText = "UPDATEONORDER"
'    Objcmd.CommandType = adCmdStoredProc
'     Set Objcmd.ActiveConnection = DBconn
'    Objcmd.Execute
        
    CrystalReport1.RetrieveStoredProcParams
    CrystalReport1.StoredProcParam(0) = Format$(FrmReportDateRange.bdate, "mm/dd/yy")
    CrystalReport1.StoredProcParam(1) = Format$(FrmReportDateRange.edate, "mm/dd/yy")
    CrystalReport1.Action = 1
    Unload FrmReportDateRange
Else
    CrystalReport1.RetrieveStoredProcParams
    CrystalReport1.Destination = crptToWindow
    CrystalReport1.Action = 1
End If

End Sub



Private Sub OptReport_Click(Index As Integer)
Select Case Index
    Case 0
        ReportName = "INV200new.rpt"
    Case 1
        ReportName = "INV220.rpt"
    Case 2
        ReportName = "INV230.rpt"
    Case 3
        ABCReport
        ReportName = "INV240.rpt"
    Case 4
        ReportName = "INV250.rpt"
    Case 5
        ReportName = "INV260.rpt"
     
End Select
End Sub
